USE EMODE_sauvegarde 
go 

alter table shop_facts drop constraint shop_facts_article_color_lookup_fk;
alter table shop_facts drop constraint shop_facts_outlet_lookup_fk;
alter table shop_facts drop constraint shop_facts_article_lookup_fk;
alter table shop_facts drop constraint shop_facts_calendar_year_lookup_fk;
alter table article_lookup_criteria drop constraint article_lookup_criteria_fk;
alter table product_promotion_facts drop constraint product_promotion_facts_art_look_fk;
alter table product_promotion_facts drop constraint product_promotion_facts_calendar_fk;

TRUNCATE TABLE shop_facts;
TRUNCATE TABLE shop_facts_reject;

TRUNCATE TABLE product_promotion_facts;
TRUNCATE TABLE product_promotion_facts_rej;

TRUNCATE TABLE article_color_lookup;
TRUNCATE TABLE article_color_reject;

TRUNCATE TABLE outlet_lookup;
TRUNCATE TABLE outlet_reject

TRUNCATE TABLE article_lookup;
TRUNCATE TABLE article_reject;

TRUNCATE TABLE calendar_year_lookup;
TRUNCATE TABLE calendar_year_reject;

TRUNCATE TABLE article_lookup_criteria;
TRUNCATE TABLE article_lookup_criteria_reject;

TRUNCATE TABLE promotion_lookup;
TRUNCATE TABLE promotion_lookup_reject;

TRUNCATE TABLE unused_outlet_lookup_full;
TRUNCATE TABLE unused_outlet_lookup_full_rej;

alter table shop_facts add constraint shop_facts_article_color_lookup_fk foreign key (article_code, color_code) references article_color_lookup (article_code, color_code);
alter table shop_facts add constraint shop_facts_outlet_lookup_fk foreign key (shop_code) references outlet_lookup (shop_code);
alter table shop_facts add constraint shop_facts_article_lookup_fk foreign key (article_code) references article_lookup (article_code);
alter table shop_facts add constraint shop_facts_calendar_year_lookup_fk foreign key (week_key) references calendar_year_lookup (week_key);
alter table ARTICLE_LOOKUP_CRITERIA add constraint ARTICLE_LOOKUP_CRITERIA_FK foreign key(ARTICLE_CODE) references ARTICLE_LOOKUP(ARTICLE_CODE);
alter table PRODUCT_PROMOTION_FACTS add constraint PRODUCT_PROMOTION_FACTS_ART_LOOK_FK foreign key(ARTICLE_CODE) references ARTICLE_LOOKUP(ARTICLE_CODE);
alter table PRODUCT_PROMOTION_FACTS add constraint PRODUCT_PROMOTION_FACTS_CALENDAR_FK foreign key(WEEK_KEY) references CALENDAR_YEAR_LOOKUP(WEEK_KEY);